EMT Practice Test

1. Question Content...

---

Question1: Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State.
Add a Linear trend line to the view. What is its R-squared value?

Question2: Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

Question3: What is the one most important thing you should do after creating a Dual-axis chart?

Question4: Which of the following would you use to connect to multiple tables in a single data source at once?

Question5: For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Question6: You can create _______________ for members in a dimension so that their labels appear differently in the view.

Question7: How can you format an axis as Bold in Tableau?

Question8: Which of the following is not a Trend Line Model?

Question9: __________ is a technique in Tableau which will identify marks with similar characteristics

Question10: Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

Question11: You can use the __________________ in Tableau to clean / organise your data.

Question12: Data blending simulates a traditional _________________ Join

Question13: Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Question14: A field that shows average home values for the United States in 2016 is most likely :

Question15: When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Question16: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question17: True or False: A reference line cannot be added from the Analytics Pane

Question18: Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Question19: True or False: All rows from both tables are returned in an INNER JOIN

Question20: True or False : Bins can be created on dimensions

Question21: Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

Question22: Which of the following is a benefit of using a Tableau Data Source (.tds)?

Question23: Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

Question24: What will the following function return?
LEFT("Tableau", 3)

Question25: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question26: When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Question27: True or False: Context Filters are executed after Data Source filters

Question28: Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Question29: The default path for all supporting files, data sources, icons, logs etc is in ______________________

Question30: Is SUM a table calculation?

Question31: Which of the following charts types always includes bars sorted in descending order?

Question32: What is the following icon in the Data pane used to do?
Larger image

Question33: Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Question34: Larger image

What is this view referred to as in Tableau?

Question35: Which of the following are valid ways to copy a worksheet visualisation as an image?

Question36: How can you change the default Tableau repository location?

Question37: Which of the following is NOT a valid official data source in Tableau Desktop?

Question38: To use a quick table calculation, which of the following programming languages do you need to know?

Question39: When using Animations in a Tableau, which of the following is the default duration for animations?

Question40: By default, measures placed in a view are aggregated by ______________

Question41: Which of the following calculations DO NOT need a quick table calculation?

Question42: The row and column shelves contain ___________________

Question43: What is a story point in Tableau?

Question44: Which one of the following is a dimension?

Question45: Which of the following are valid ways to show Mark Labels in the visualisation?

Question46: Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Question47: What is the minimum amount of RAM recommended for any production use of Tableau Server?

Question48: _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

Question49: Which of the following 2 columns CANNOT be deleted in Tableau?

Question50: True or False: It is possible to add a field to more than one hierarchy

Question51: Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Question52: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question53: True or False: Tableau can create worksheet-specific filters

Question54: If you see the following Filter, then you're working with _______________________ Larger image